Steps to create database, download SQL file and execute query to create tables and populate data. 6
1. How to create database in SQL?
i . Open your SQL Server Management Studio
a. Click on Start button/ window icon on left bottom corner of your screen
b. Find Microsoft SQL Server Management Studio and click it.
c. Provide your server name ( if already not selected ) and click connect.
ii. Create Database
a. Right clicks on Database
b. Click on New Database
c. Write Database Name e.g. (DataWarehouse)
d. Click Ok
e. Refresh the database.
iii. How to download the Sql file?
a. Click on the Red Icon on the top of the page to download the data File.
b. Extract the file once the download is complete by clicking on the Downloaded folder on the left bottom corner (Status bar) or go to folder location and open it, Automatically Opens in SQL Server Management Studio.
Or,
you have access to basecamp:
a.
Go to basecamp (https://3.basecamp.com/3945211/projects)
b.
Click on internship program
c.
Then click on Doc’s & file
d.
Click on Project files
e.
Click on Zendesk file
f.
Then click on Zendesk in Tableau
g.
Then click on Download Zendesk Data Mart. Sql
1.
x
R Run the SQL script ( Follow the Previous steps (iii. b & c)
A After creating database and tables , table automatically loaded data.
A
A
a
1. How to create database in SQL?
i . Open your SQL Server Management Studio
a. Click on Start button/ window icon on left bottom corner of your screen
b. Find Microsoft SQL Server Management Studio and click it.
c. Provide your server name ( if already not selected ) and click connect.
ii. Create Database
a. Right clicks on Database
b. Click on New Database
c. Write Database Name e.g. (DataWarehouse)
d. Click Ok
e. Refresh the database.
iii. How to download the Sql file?
a. Click on the Red Icon on the top of the page to download the data File.
b. Extract the file once the download is complete by clicking on the Downloaded folder on the left bottom corner (Status bar) or go to folder location and open it, Automatically Opens in SQL Server Management Studio.
Or,
you have access to basecamp:
a.
Go to basecamp (https://3.basecamp.com/3945211/projects)
b.
Click on internship program
c.
Then click on Doc’s & file
d.
Click on Project files
e.
Click on Zendesk file
f.
Then click on Zendesk in Tableau
g.
Then click on Download Zendesk Data Mart. Sql
1.
x
R Run the SQL script ( Follow the Previous steps (iii. b & c)
A After creating database and tables , table automatically loaded data.
A
A
a